package com.bupt.kgplatform.mapper;

import com.bupt.kgplatform.entity.pojo.MeetingData;
import com.bupt.kgplatform.entity.pojo.MeetingDocument;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * ClassName:DCollectionMapper
 * Package:com.example.blackjavaweb.mapper
 * Description:
 *
 * @Author QIQI_1999
 * @Creat 2023/9/10 17:05
 * @Version 1.0
 */
@Mapper
public interface DCollectionMapper {
    @Select("select url from markinfo where before_mark = #{searchInfoLabel}")
    public List<String> getMarkInfoUrl(String searchInfoLabel);

//    @Select("select count(*) from  meetingdata where url in #{urlLIsts}")
    Integer getMeetingDataCount(List<String> urlLists);

//    @Select("select count(*) from  meeting_document where meeting_url in #{urlLIsts}")
    Integer getMeetingDocumentCount(List<String> urlLists);

//    @Select("select id,meeting_type, meeting_time ,meeting_num from meetingdata where meeeting_url in #{urlLIsts} limit #{start}, #{num}")
    List<MeetingData> getMeetingInfoByUrl(List<String> urlLists, int start, int num);

//    @Select("select id,meeting_type, meeting_time ,meeting_num from meetingdata where meeeting_url in #{urlLIsts} limit #{i}, #{start2}")
    List<MeetingDocument> getMeetingDocumentByUrl(List<String> urlLists, int i, int start2);


}
